This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.

library(tidyverse)
# Install Package to combine date and time
library(lubridate)

wego <- read_csv("../data/Route 50 Timepoint and Headway Data, 1-1-2023 through 5-12-2025.csv")
wego
# Create new date time column
wego$DATE_TIME <- ymd(wego$DATE) + hms(wego$SCHEDULED_TIME)

# Examine Data
wego


# Filter February TSP values
feb3_10_tsp <- wego |> 
  filter(between(DATE_TIME, 
                 as.Date("2025-02-03 12:00:00"), 
                 as.Date("2025-02-10 12:00:00")))

# Filter Feb-Apr TSP with busses only 2 minutes late or more
feb10_apr28_tsp <- wego |> 
  filter(between(DATE_TIME, 
                 as.Date("2025-02-10 12:00:00"), 
                 as.Date("2025-04-28 12:00:00"))) |> 
  filter(ADHERENCE <= -2)

# Filter May TSP values
may5_12_tsp <- wego |> 
  filter(between(DATE_TIME, 
                 as.Date("2025-05-05 12:00:00"), 
                 as.Date("2025-05-12 12:00:00")))

  

# Add day of week column
wego <- wego |>
  mutate(
    DATE_TIME = as.POSIXct(DATE_TIME),
    DAY_OF_WEEK = wday(DATE_TIME, 
                       label = TRUE, 
                       abbr = FALSE))

wego
NA

# Combine tsp variables into one 
tsp_rows <- bind_rows(
  feb3_10_tsp,
  feb10_apr28_tsp,
  may5_12_tsp
) |> 
  select('ADHERENCE_ID', 'DATE_TIME') |> 
  distinct() |> 
  mutate(tsp = 1)  # Add tsp indicator column for each distinct adherence id

wego <- wego |> 
  left_join(
    tsp_rows,
    by = c('ADHERENCE_ID', 'DATE_TIME')
  ) |> 
  mutate(tsp = coalesce(tsp, 0))

wego |> view()

wego |>  mutate(
  tsp_indicator = if_else(
    between(DATE_TIME, 
            as.Date("2025-02-03 12:00:00"), 
            as.Date("2025-02-10 12:00:00")) |
    (between(DATE_TIME, 
            as.Date("2025-02-10 12:00:00"), 
            as.Date("2025-04-28 12:00:00")) &
       ADHERENCE <= -2) |
    between(DATE_TIME, 
            as.Date("2025-05-05 12:00:00"), 
            as.Date("2025-05-12 12:00:00")), 1, 0)
    
  )
NA
wego <- wego |> mutate(
  HOUR = hms(SCHEDULED_TIME) |> 
    hour()
  )
# avg adherence based on time of day

wego |>
  mutate(
    time_of_day = case_when(
      between(HOUR, 4, 5) ~ "early_morning",
      between(HOUR, 6, 8) ~ "morning_peak",
      between(HOUR, 9, 14) ~ "midday",
      between(HOUR, 15, 17) ~ "pm_peak",
      between(HOUR, 18, 20) ~ "evening",
      between(HOUR, 21, 23) ~ "late_night",
      between(HOUR, 0, 3) ~ "late_night",
      .default = "other"
    )
  )
NA
NA
NA
NA
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KDQpUaGlzIGlzIGFuIFtSIE1hcmtkb3duXShodHRwOi8vcm1hcmtkb3duLnJzdHVkaW8uY29tKSBOb3RlYm9vay4gV2hlbiB5b3UgZXhlY3V0ZSBjb2RlIHdpdGhpbiB0aGUgbm90ZWJvb2ssIHRoZSByZXN1bHRzIGFwcGVhciBiZW5lYXRoIHRoZSBjb2RlLiANCg0KVHJ5IGV4ZWN1dGluZyB0aGlzIGNodW5rIGJ5IGNsaWNraW5nIHRoZSAqUnVuKiBidXR0b24gd2l0aGluIHRoZSBjaHVuayBvciBieSBwbGFjaW5nIHlvdXIgY3Vyc29yIGluc2lkZSBpdCBhbmQgcHJlc3NpbmcgKkN0cmwrU2hpZnQrRW50ZXIqLiANCg0KYGBge3J9DQoNCg0KDQpgYGANCg0KQWRkIGEgbmV3IGNodW5rIGJ5IGNsaWNraW5nIHRoZSAqSW5zZXJ0IENodW5rKiBidXR0b24gb24gdGhlIHRvb2xiYXIgb3IgYnkgcHJlc3NpbmcgKkN0cmwrQWx0K0kqLg0KDQpXaGVuIHlvdSBzYXZlIHRoZSBub3RlYm9vaywgYW4gSFRNTCBmaWxlIGNvbnRhaW5pbmcgdGhlIGNvZGUgYW5kIG91dHB1dCB3aWxsIGJlIHNhdmVkIGFsb25nc2lkZSBpdCAoY2xpY2sgdGhlICpQcmV2aWV3KiBidXR0b24gb3IgcHJlc3MgKkN0cmwrU2hpZnQrSyogdG8gcHJldmlldyB0aGUgSFRNTCBmaWxlKS4NCg0KVGhlIHByZXZpZXcgc2hvd3MgeW91IGEgcmVuZGVyZWQgSFRNTCBjb3B5IG9mIHRoZSBjb250ZW50cyBvZiB0aGUgZWRpdG9yLiBDb25zZXF1ZW50bHksIHVubGlrZSAqS25pdCosICpQcmV2aWV3KiBkb2VzIG5vdCBydW4gYW55IFIgY29kZSBjaHVua3MuIEluc3RlYWQsIHRoZSBvdXRwdXQgb2YgdGhlIGNodW5rIHdoZW4gaXQgd2FzIGxhc3QgcnVuIGluIHRoZSBlZGl0b3IgaXMgZGlzcGxheWVkLg0KDQpgYGB7cn0NCmxpYnJhcnkodGlkeXZlcnNlKQ0KIyBJbnN0YWxsIFBhY2thZ2UgdG8gY29tYmluZSBkYXRlIGFuZCB0aW1lDQpsaWJyYXJ5KGx1YnJpZGF0ZSkNCg0Kd2VnbyA8LSByZWFkX2NzdigiLi4vZGF0YS9Sb3V0ZSA1MCBUaW1lcG9pbnQgYW5kIEhlYWR3YXkgRGF0YSwgMS0xLTIwMjMgdGhyb3VnaCA1LTEyLTIwMjUuY3N2IikNCg0KYGBgDQpgYGB7cn0NCndlZ28NCmBgYA0KDQpgYGB7cn0NCiMgQ3JlYXRlIG5ldyBkYXRlIHRpbWUgY29sdW1uDQp3ZWdvJERBVEVfVElNRSA8LSB5bWQod2VnbyREQVRFKSArIGhtcyh3ZWdvJFNDSEVEVUxFRF9USU1FKQ0KDQojIEV4YW1pbmUgRGF0YQ0Kd2Vnbw0KYGBgDQoNCmBgYHtyfQ0KDQoNCiMgRmlsdGVyIEZlYnJ1YXJ5IFRTUCB2YWx1ZXMNCmZlYjNfMTBfdHNwIDwtIHdlZ28gfD4gDQogIGZpbHRlcihiZXR3ZWVuKERBVEVfVElNRSwgDQogICAgICAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDItMDMgMTI6MDA6MDAiKSwgDQogICAgICAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDItMTAgMTI6MDA6MDAiKSkpDQoNCiMgRmlsdGVyIEZlYi1BcHIgVFNQIHdpdGggYnVzc2VzIG9ubHkgMiBtaW51dGVzIGxhdGUgb3IgbW9yZQ0KZmViMTBfYXByMjhfdHNwIDwtIHdlZ28gfD4gDQogIGZpbHRlcihiZXR3ZWVuKERBVEVfVElNRSwgDQogICAgICAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDItMTAgMTI6MDA6MDAiKSwgDQogICAgICAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDQtMjggMTI6MDA6MDAiKSkpIHw+IA0KICBmaWx0ZXIoQURIRVJFTkNFIDw9IC0yKQ0KDQojIEZpbHRlciBNYXkgVFNQIHZhbHVlcw0KbWF5NV8xMl90c3AgPC0gd2VnbyB8PiANCiAgZmlsdGVyKGJldHdlZW4oREFURV9USU1FLCANCiAgICAgICAgICAgICAgICAgYXMuRGF0ZSgiMjAyNS0wNS0wNSAxMjowMDowMCIpLCANCiAgICAgICAgICAgICAgICAgYXMuRGF0ZSgiMjAyNS0wNS0xMiAxMjowMDowMCIpKSkNCg0KICANCmBgYA0KDQoNCg0KDQpgYGB7cn0NCg0KIyBBZGQgZGF5IG9mIHdlZWsgY29sdW1uDQp3ZWdvIDwtIHdlZ28gfD4NCiAgbXV0YXRlKA0KICAgIERBVEVfVElNRSA9IGFzLlBPU0lYY3QoREFURV9USU1FKSwNCiAgICBEQVlfT0ZfV0VFSyA9IHdkYXkoREFURV9USU1FLCANCiAgICAgICAgICAgICAgICAgICAgICAgbGFiZWwgPSBUUlVFLCANCiAgICAgICAgICAgICAgICAgICAgICAgYWJiciA9IEZBTFNFKSkNCg0Kd2Vnbw0KDQpgYGANCg0KDQpgYGB7cn0NCg0KIyBDb21iaW5lIHRzcCB2YXJpYWJsZXMgaW50byBvbmUgDQp0c3Bfcm93cyA8LSBiaW5kX3Jvd3MoDQogIGZlYjNfMTBfdHNwLA0KICBmZWIxMF9hcHIyOF90c3AsDQogIG1heTVfMTJfdHNwDQopIHw+IA0KICBzZWxlY3QoJ0FESEVSRU5DRV9JRCcsICdEQVRFX1RJTUUnKSB8PiANCiAgZGlzdGluY3QoKSB8PiANCiAgbXV0YXRlKHRzcCA9IDEpICAjIEFkZCB0c3AgaW5kaWNhdG9yIGNvbHVtbiBmb3IgZWFjaCBkaXN0aW5jdCBhZGhlcmVuY2UgaWQNCg0Kd2VnbyA8LSB3ZWdvIHw+IA0KICBsZWZ0X2pvaW4oDQogICAgdHNwX3Jvd3MsDQogICAgYnkgPSBjKCdBREhFUkVOQ0VfSUQnLCAnREFURV9USU1FJykNCiAgKSB8PiANCiAgbXV0YXRlKHRzcCA9IGNvYWxlc2NlKHRzcCwgMCkpDQoNCmBgYA0KDQoNCmBgYHtyfQ0KDQoNCmBgYA0KDQoNCmBgYHtyfQ0KDQp3ZWdvIHw+IHZpZXcoKQ0KDQoNCmBgYA0KDQoNCmBgYHtyfQ0KDQp3ZWdvIHw+ICBtdXRhdGUoDQogIHRzcF9pbmRpY2F0b3IgPSBpZl9lbHNlKA0KICAgIGJldHdlZW4oREFURV9USU1FLCANCiAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDItMDMgMTI6MDA6MDAiKSwgDQogICAgICAgICAgICBhcy5EYXRlKCIyMDI1LTAyLTEwIDEyOjAwOjAwIikpIHwNCiAgICAoYmV0d2VlbihEQVRFX1RJTUUsIA0KICAgICAgICAgICAgYXMuRGF0ZSgiMjAyNS0wMi0xMCAxMjowMDowMCIpLCANCiAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDQtMjggMTI6MDA6MDAiKSkgJg0KICAgICAgIEFESEVSRU5DRSA8PSAtMikgfA0KICAgIGJldHdlZW4oREFURV9USU1FLCANCiAgICAgICAgICAgIGFzLkRhdGUoIjIwMjUtMDUtMDUgMTI6MDA6MDAiKSwgDQogICAgICAgICAgICBhcy5EYXRlKCIyMDI1LTA1LTEyIDEyOjAwOjAwIikpLCAxLCAwKQ0KICAgIA0KICApDQoNCmBgYA0KDQpgYGB7cn0NCndlZ28gPC0gd2VnbyB8PiBtdXRhdGUoDQogIEhPVVIgPSBobXMoU0NIRURVTEVEX1RJTUUpIHw+IA0KICAgIGhvdXIoKQ0KICApDQoNCmBgYA0KDQpgYGB7cn0NCg0Kd2VnbyB8Pg0KICBtdXRhdGUoDQogICAgdGltZV9vZl9kYXkgPSBjYXNlX3doZW4oDQogICAgICBiZXR3ZWVuKEhPVVIsIDQsIDUpIH4gImVhcmx5X21vcm5pbmciLA0KICAgICAgYmV0d2VlbihIT1VSLCA2LCA4KSB+ICJtb3JuaW5nX3BlYWsiLA0KICAgICAgYmV0d2VlbihIT1VSLCA5LCAxNCkgfiAibWlkZGF5IiwNCiAgICAgIGJldHdlZW4oSE9VUiwgMTUsIDE3KSB+ICJwbV9wZWFrIiwNCiAgICAgIGJldHdlZW4oSE9VUiwgMTgsIDIwKSB+ICJldmVuaW5nIiwNCiAgICAgIGJldHdlZW4oSE9VUiwgMjEsIDIzKSB+ICJsYXRlX25pZ2h0IiwNCiAgICAgIGJldHdlZW4oSE9VUiwgMCwgMykgfiAibGF0ZV9uaWdodCIsDQogICAgICAuZGVmYXVsdCA9ICJvdGhlciINCiAgICApDQogICkNCiAgDQoNCg0KDQpgYGANCmBgYHtyfQ0KYGBgDQoNCg0KYGBge3J9DQpgYGANCg0KDQpgYGB7cn0NCmBgYA0KDQoNCmBgYHtyfQ0KYGBgDQoNCg0KYGBge3J9DQpgYGANCg0KDQpgYGB7cn0NCmBgYA0KDQoNCg0KDQoNCg0KDQo=